ABS()
absolute value

ACOS()
arccosine in radians

AND(arg1,arg2..,arg14)
boolean (true or false)

AREAS(ranges)
number of ranges

ASIN()
arcsine in radians

ATAN()
arctangent in radians

ATAN2(x,y)
arctangent of opposite/adj

AVERAGE(arg1,..arg14)
returns  average value

CHOOSE(index,arg1,arg2...)
returns the arg of index

COLUMN()
returns the column#

COLUMNS(array)
returns the number of columns

COS()
cosine of arg in radians

COUNT(arg1,arg2..,arg14)
count of the numbers in list

DATE(y,m,d)
returns serial number

DAY(serial#),MONTH(),YEAR(),WEEKDAY()
returns day# of serial#

DOLLAR(num,numdigits)
returns text value

EXP(n)
e to the power of n

FIXED(number,number of digits)
example:FIXED(1.2345,2)="1.23"

FV(rate,periods,pmt,pv,0 or 1)
0 if pmt at beginning,1 if end

HLOOKUP(value,array,row)
looks for array<=value and returns value in row

VLOOKUP(value,array,column)
returns value in column

HOUR(serial#),MINUTE(),SECOND()
returns h(0-23),m,secs numbers

IF(logical,value if true,value if false)
example:if(and(x=1,y=2),3,4)

INDEX(array,row,column)
?

INT()
returns whole rounded down

ISERROR(value)
returns true if valid error

ISNA(value)
returns true if #N/A

ISREF(value)
returns true if #REF!

LEN(text)
length of text

LN(number)
natural log LN(EXP(1))=1

LOG10(number)
log base 10

LOOKUP(value,compare,result)
like HLOOKUP except result is a range

LOOKUP(value,range)
looks in all rows

MATCH(value,compare,[type])
type:1 just lower,2 just higher,0 equal

MAX(arg1,arg2..,arg14)
returns highest value among args

MID(text,start,number of characters)
example: MID("Hello",2,3)="ell"

MIN(arg1,arg2,..arg14)
returns minimum value among args

MOD(number,divisor)
returns remainder

NOT(logical)
returns true if false, false if true

NOW()
serial number of current date-time

NPER(rate,pmt,pv,[fv,type])
returns the number of periods

NPV(rate,value1,..value14)
net present value

OR(log1,log2..,log14)
like AND

PI()
3.1415926535898

PMT(rate,nper,pv,[fv,type])
returns the payment

PV(rate,nper,,pmt,fv,[type])
present value of pmt

RAND()
returns a random number 0 to .999

RATE(nper,pmt,[pv,fv,type,guess])
returns the rate

REPT(text,num of times)
example: REPT(""a"",3)="aaa"

ROUND(number,number of digits)
like INT but rounds UP

ROW()
like COLUMN()

ROWS(array)
like COLUMNS

SEARCH(subtext,text,start-number)
returns pos of subtext

SIGN(number)
returns 1,0, or -1

SIN(arg)
sine of number in radians

SQRT()
returns square root

SUM(arg1,arg2,..arg14)
returns the sum

TAN(arg)
tangent of number in radians

TEXT(number,format)
example:TEXT(2.7034,"$0.00")=$2.70"

TIME(h,m,s)
returns serial number

TRUE()
returns TRUE

TYPE(value)
1=num,2=text,4=log,16=err,64=array

VALUE(text)
example:VALUE("$1,000")=1000